The Upcoming Maturing Loans Report gives details of Loans whose installment repayment period has expired and they have not yet been fully recovered/repaid.
To get here, go to Loans/Portfolio Reports/Upcoming Maturing Loans Report.. A screen like one below will appear:
Reporting date from: Enter the date that you want the Upcoming Maturing Loans Report to start e.g. "01/01/2018". and in the to section enter the date when the Upcoming Maturing Loans Report will stop. e.g. "31/08/2018" as seen above.
Include all loans, not just outstanding loans: When this option is ticked, the system will not only displays the dues and past due loans but also those loans that were due and were paid off during that period range. However those loans that were paid off during that period will be reflected in the report with zero principal balance and zero interest balance. See the report below:
Branch Code: Select a branch for which you want to generate a report. In the example above, we have checked "For all" option to have a report for all branches. In case you are using a Demo Database, then the default will be DB in the options in the drop down box.
Credit Officer: Select from the drop down box a particular credit officer whom you want to generate a report about, this may be to see the number of Upcoming Maturing Loans handled by that officer selected. In the example, the "For all" option is checked, this is in order to have a report on all credit officers who may have Upcoming Maturing Loans. Credit officers need to have been registered under System Configuration/Users/Add a User then choose the function of credit officer.
Loan Fund: From the drop down box, select a particular Loan Fund that you want to generate a report about the Upcoming Maturing Loans Report. The Loan Fund is set at Menu System/Configuration/Funds. In the example, the "For all" option is checked, this is in order to have a report on all Funds that are available in the system.
Geographical Area: From the drop down box, you can select a particular area or location or region of which you would like to generate a report about. For example Districts, County, Sub-County and Parish as specified in your settings under Menu Support Files/Geographical Area's. In the example, the "For all" option is selected in order to have an Upcoming Maturing Loans Report on all geographical areas.
Loan Product: From the drop down box, select a loan Product that you want to generate a report about. The Loan product depends on what was set at Menu System/Configuration/Products. You may have Loan Products like School Fees Loans, Agricultural Loans etc. In the example above, the "For all" option is selected in order to have an Upcoming Maturing Loans Report on all Loan Products.
Business Sector: From the drop down box, select a business sector from which you want to generate a report about. This can be Agriculture, Industry, Services or any other depending on what you set at Menu Support files/Business Sector. In the example above, the "For all" option is selected to have an Upcoming Maturing Loans Report of all sectors that were granted loans in the selected period.
Grouping/Order: Select from the drop down box how the report to be generated will be classified in the column title/heading. In the example above, we select Client Name.
Report Format: Select from the drop down box the sequence in which the column titles in your report will appear (in all options, the column headings will begin with the Loan Number). In the example, the first option is selected.
Client Category 1: From the drop down box, select a client based on the classification that you made at Menu Support Files/Client Category 1. In the example, the "For all" option is checked. The same applies for Client Category 2 and client Category 3.
Loan Category 1: From the drop down box, select a classification of a loan that you made at Menu Support Files/Loan Category 1, it may have been a long term loan, short term loan etc. In the example, the "For all" option is checked. The same applies for Loan Category 2 and Loan Category 3.
Guarantee Items: Select an item that was used as security for loans from the drop down box. These are set at Menu Support Files/ Loan Guarantee Items.
Additional filtering options? : This option is used to get a particular field or specification that you want. It helps you to narrow down the information that you need. When you check this option and click ok, a pop up screen will appear.
In the screen above, the filter criteria selected is Loan amount LAMOUNT (3,200,000) from the drop down box, The Relational operator checked is '=' (Equals sign) and the VALUE is interest amount of INTAMOUNT(560,000). Click the OK button. You will get a pop up message that says "Your filter for this report is LAMOUNT=3,200.000 AND INTAMOUNT=560,000. Are you sure you want to continue?"
When you click the Yes button, you will be able to generate an Upcoming Maturing Loans Report that is of loan amount 3,200,000 and interest of 560,000 and will look as one below;
However without filtering except for the "Include all loans, not just outstanding loans:" option ticked, the report will appear as below:
Click on the Close command button to exit the menu.